Managing Database Configurations

This topic provides an overview about Database Configurations.

In Process Platform, some application connectors are configured to use relational database for storage and retrieval of data. Database connection details for these application connectors have to be specified during Service Containers configuration, for the application connectors to use this information to connect to the database.

Database related configuration is stored in a common location in the repository so that all application connectors can reuse the configuration referred by a name. This section will detail on how you can create, store and reuse database configurations in Process Platform.

A Database Configuration consists of the following fields which are associated with a descriptive name and stores the configuration details (drivers and settings) of a database.

• For OLEDB driver
  • Database Vendor
  • Provider
  • Machine Name
  • Default Database
  • DB User
  • Password
    
• For JDBC driver
  • JDBC Driver
  • Driver Class
  • Connection String
  • JDBC Driver XA Class
  • Default Database
  • DB User
  • Password
    
    While configuring Services, you can reuse a stored database configuration, without having to enter the details. You can manage a database configuration through the following tasks:
    
    
• Creating a Database Configuration
  
• Editing a Database Configuration
  
• Deleting a Database Configuration
  You can also view the usage report of a database configuration.